
clear all
set mem 100m

local path0="C:\Dropbox\GeneticsProject (1)\REStat\round_accepted_replication_files\"

cd "`path0'Workfiles\"
set more off

insheet using "`path0'Data\Culture_measures\Hofstede.csv", names clear

label var pdi	"Hofstede: Power Distance Index"
label var idv	"Hofstede: Individualism"
label var mas	"Hofstede: Masculinity"
label var uai	"Hofstede: Uncertainty Avoidance Index"
label var lto	"Hofstede: Long-Term Orientation"

rename  countryisocode  countrycode
drop if countrycode==""

rename idv idv1
joinby countrycode using "`path0'Data\Culture_measures\idv_updated", unmatched(both)

tab _merge
corr idv idv1
drop idv1

drop _merge

keep countrycode idv 
compress
save culture_Hofstede, replace

